import pandas as pd

df = pd.read_excel('https://www.gairuo.com/file/data/dataset/team.xlsx')
print(df.head(10))
df = df.groupby('team').first()
print(df)

df.dropna()
print(df.columns)
print(df.shape[0])
df.dropna()
print(df.shape[0])
df = df.reset_index().set_index('name')
df = df[df.Q1 > 50]
df = df.loc[: , ['team' ,'Q1']]

print(df)
